M&IS 24060: Systems Analysis I, Fall 2002

Dr. Murali Shanker, A401 BSA

Dr. J. Randall Brown

E-mail: mshanker@kent.edu

E-mail: rbrown@bsa3.kent.edu

Phone: (330) 672-1165

Phone: (330) 672-1150

IM: AOL mshanker1; Yahoo mshanker1

Office Hours: 12:30-1:30; 5:00-5:30 T and TH, and by appointment

Course Web Site : https://class.kent.edu

Section 001 : 1:45-3:00 PM T, TH, 206 BSA (Final Exam: 11 December 2002; 12:45 - 2:00 PM)
Section 002 : 5:30-6:45 PM T, TH, 206 BSA (Final Exam: 10 December 2002; 5:45 - 7:00 PM)

Course Requirements

Last day to drop a course: 2 November 2002
Prerequisites: M&IS 24053, Introduction to Computer Applications.  Students attending the course who do not have the proper prerequisite risk being deregistered from the class.

Enrollment: It is the student’s responsibility to ensure proper enrollment in classes. You are advised to review your official class schedule during the first two weeks of the semester to ensure proper enrollment. Should you determine an error in your class schedule, you have until 7 September 2002 to correct it with your advising office. If registration errors are not corrected by this date and you continue to attend and participate in classes for which you are not officially enrolled, you are advised now that you will not receive a grade at the conclusion of the semester.

Students With Disabilities: In accordance with University policy, if you have a documented disability and require accommodations to obtain equal access in this course, please contact the instructor at the beginning of the semester or when given an assignment for which an accommodation is required. Students with disabilities must verify their eligibility through the Office of Student Disability Services (SDS) located in room 181 of the Michael Schwartz Student Services Center (Voice/TTD: 672-3391).

Academic Honesty: Cheating means to misrepresent the source, nature, or other conditions of your academic work (e.g., tests, papers, projects, assignments) so as to get undeserved credit.  The use of intellectual property of others without giving them appropriate credit is a serious academic offense.  It is the University’s policy that cheating or plagiarism result in receiving a failing grade for the work or course.  Repeat offenses result in dismissal from the University.

Projects, Quizzes, and Examinations

There will be three projects to be turned in, three in-class group projects, four online quizzes, and three exams in this course. The breakdown is as follows:

Exams: All exams are closed book, multiple choice, and machine graded.  Don’t forget to bring a pencil and eraser to the test.  Exam 2 and the final exam are comprehensive.

Homework: Homework will not be collected as the solutions are in the Class Notes and the book.  Each student should expect to spend approximately 6 hours per week working on the course outside of class.

Projects: Each project is due at the beginning of class on the day listed in the table on the next page.  As with exams, a project can be handed in early but cannot be handed in late.  HINT: Projects 2 and 3 are especially time consuming so start them early.

Group Tasks: Each of the three group tasks will take two class periods for a total of eight class periods.  You will be arbitrarily assigned to a group to simulate what happens in business.  Your assigned group is listed on the WebCT site.  All group tasks will be done entirely in class so attendance is essential.  Attendance will be taken and you will receive 10 points for each of the six class periods you attend and 5 points if you attend both class periods for a task (like exams, there are no excused absences).  Note that the objective is for you to participate in the group discussions and presentations.  At the instructor’s discretion, anyone not making an effort to participate will not receive the 10 points for the class period even though they were physically present.  In addition, students who are more than one minute late for their group sessions will not receive the 10 points.

Grades

Grading Scale: A: 810—914 points, B: 720—809 points, C: 630—719 points, D: 540—629 points, and F: 0—539 points.

None of the quizzes or exams can be made up. You will receive a score of zero (0) for any missed quizzes/exams. An exam may be taken early (see instructor), but cannot be taken late.  There are no exceptions (remember, the lowest grade exam is automatically dropped). Exam, quiz, and project dates are listed in the tables below.

Course Material

Required Text: Paul Cassel and Pamela Palmer. SAMS Teach Yourself Access 2000 in 21 Days, Sams Publishing, 1999. ISBN: 0-672-31292-1

Required Class Notes: Systems Analysis I, Notes, Fall 2002.  May be purchased for $30.00 from Dr. Shanker in his office (Room A401 BSA) with cash or a check payable to “Cash”.  Any class notes from previous semesters do not contain the current changes and additions so you need the current semester’s class notes.

Computer Labs: All computers in the BSA computer lab have Access 2000 and a CD-ROM.  In addition, the computer labs in Bowman. the Library, the Student Center, and Music and Speech also have Access 2000.  The BSA computer lab is open Monday through Thursday from 9AM to 11PM, Friday from 9AM to 9PM, Saturday from 9AM to 5PM, and Sunday from 12 noon to 6PM.  Finally, CD’s to install Office XP on your computer can be purchased from the KSU Bookstore for $20.00.

How to Access and Use Your Course Web Site

This course use a system called WebCT to organize and present online content. WebCT allows the instructor to provide a comprehensive solution to presenting online content, and student management. Thus, in addition to taking online examinations, and reading material from online content, the student is able to track their progress, interact with fellow students through chat and e-mail, and even make online presentations. The following pages give a brief introduction to WebCT for your course.

Before you can access this course, you must create a myWebCT account. This account will be the starting point for all courses using the WebCT system.

  1. Click on myWebCT to log in. If you are unsure how to log in, click on Help.
  2. Enter your username and password (see below).
  3. Choose Add a Course, and select M&IS: Systems Analysis I. The course should be visible under Main.
  4. Click on the course to access your Homepage for that course.

Everyone needs a User Name and password to log on to WebCT. They are the same as the ones used for your KSU email account. The User Name and password are case-sensitive in WebCT. That means it make a difference whether you use capital letters or not.

If you already use your KSU email account and know your password you're about ready to go: read the Password Management (http://webcthelp.kent.edu/v3/student/password.html) section of this guide and then go to class.kent.edu to log in (assuming your professor has already given you access to the course). If you don't know about your KSU email account, read on.

User Name: The first step is to find out your User Name. Go to the Username Request Form (https://secure.kent.edu/userid/), enter your Social Security Number, and your user ID will be displayed. You will use it both for WebCT and for your KSU email account. (If you don't plan on using your KSU email account you should set up automatic forwarding (http://www.personal.kent.edu/forward.html) to another email account.

Course Schedule

The following tables contains the class schedule. Note that online quizzes begin on the Monday of the week they are assigned, and are available until Sunday 11:50 p.m. (ET) of that week. For example, Quiz 1 can be taken from Monday, 2 September 2002, until Sunday, 8 September 2002, 11:50 p.m.

Date Teach yourself Access 2000 Class Sections Tutorials, Detail Problems, Projects

Aug 27

Day 1

Introduction

Tutorial: Windows Explorer

Aug 29

Day 2

Database, Relational Databases 1-6.

Database Detail Problem

Sept 3

Day 3

Relational Databases 7-17
Database Design and Normalization 1-22

Relational Databases Detail Problem

Sept 5

Day 4

Database Design and Normalization 23-50

 

Sept 10

Day 5

Course Number Change Problem
Course Number Change Analysis and Design

Database Design and Normalization Detail Problem

Sept 12

Day 6

House Analogy
Models and Modeling

Northwind Database Detail Problem

Sept 17

Days 7, 8

System Design Methodology

 

Sept 19

Day 9

Data Modeling, Group Tasks Introduction
Basic Information for All Project Assignments
TASK 1: UPS Data Modeling Problem

Relationships Detail Problem

Fields Detail Problem

Sept 24

Days 10 and 11

TASK 1: Group Meetings

Queries Detail Problem

Sept 26

Day 12

TASK 1: Group Presentations
UPS – One Solution

 

Oct 1

Day 13

Process Modeling
Oracle: An Overview of a CASE Tool

 

Oct 3

Day 14

Process Analysis and Design

Project 1 Due: Query & Forms

Oct 8

Day 15

Change ADMSys.mdb To M&ISys.mdb

 

Oct 10

Day 15

Design M&IS System
Project Management Ten Commandments Problem Resolution in Workplace 

 

Oct 15

 

Exam 1 (in class) All topics to date

Exam 1

Oct 17

Day 16

Business System History 1-46

 

Oct 22

Day 16

Business System History 47-75
TASK 2: The Mail Order Enterprise Problem

 

Oct 24

Day 17

Instructor & Courses Project Discussion & Hints

 

Oct 29

Day 17

TASK 2: Group Meetings

 

Oct 31

Day 18

TASK 2: Group Presentations
The Mail Order Enterprise Epilogue

Project 2 Due: Instructor & Courses

Nov 5

Day 19

Maintaining Parks 1-60

Dots and Bangs Detail Problem

Nov 7

Day 19

Maintaining Parks 61-97
TASK 3: City Government Problem

 

Nov 12

Day 19

TASK 3: Group Meetings

Programming Detail Problem

Nov 14

Day 20

TASK 3: Group Presentations
Maintaining Parks 98-126

 

Nov 19

Day 20

Courses & Days Project Discussion & Hints
Entrepreneurs and Systems

 

Nov 21

Day 21

   

Nov 26

   

Project 3 Due: Courses & Days

Nov 28

 

Thanksgiving

 

Dec 3

Day 21

   
DEC 5   Exam 2 (in class) All topics Exam 2
Final Exam

Section 001: 11 December 2002; 12:45 - 2:00 PM
Section 002: 10 December 2002; 5:45--7:00 PM

Quiz

Topics

Start Date

End Date (11:50 PM ET)

1

Access 2000 Days 1-3, Introduction, Database, Relational Databases

September 9

September 15

2

Access 2000 Days 4-6, Database Design and Normalization,
House Analogy, Course Number Change

September 16

September 22

3

Access 2000 Days 7-11, Models and Modeling,
Systems Design Methodology, Data Modeling,
Detail Problems: Relationships, Fields, Queries

September 30

October 6

4

Access 2000 Days 16-19, Business System History,
Mail Order Enterprise, Maintaining Parks 1-97,
Detail Problems: Dots and Bangs, Programming

November 18

November 24